Release 10.1A: OpenEdge Development:
Basic Database Tools

Performing the binary dump

Use the following PROUTIL command to perform a binary dump:

proutil dbname -C dump tablename directory [ -index num ]

db-name

Specifies the database from which you want to dump. You must completely define the path.

tablename

Specifies the name of the table containing the data you want to dump.

directory

Specifies the name of the target directory into which the data will be dumped.

-index num

Specifies an index with which to dump the table’s contents. If you choose not to use this option, the command uses the primary index to dump the table.

The dump command writes the data to a dump file named table.bd, where table is the name of the table that was dumped. For example, if you dump data from the table named “customer,” the procedure creates a dump file named customer.bd in the directory you specify in the command.

Each binary dump file contains a header and a description for each record in the table. The dump file appears in the following format:

Header

Record length

Table number

Binary record

Record CRC

The file header contains information that appears in this order:

Version number.
Date and time the file was created.
Name of the table being dumped.
Number of the table being dumped.
CRC of the table being dumped.
Number of fields in the table.
Name of the database in which the table resides.
Section number.
Number of the first record.

When the dump procedure finishes, a screen message reports the number of records that were dumped and the number of kilobytes of data that were dumped.